{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Open","Getting Started","Imported Data","Organized Data","Organized Data 2","Help","DummyData"],"not_rendered":{"charts":0,"images":18,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Open","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Getting Started","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Imported Data","index":2,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
["IMPORT DATA"]
["Put your data in Cell A15."]
["If there is already data on the spreadsheet make sure to hit clear."]
["Note: For the purpose of our assignment, the \"Clear\" button gets rid of any existing data and \"Insert Dummy Data\" puts in fake info that is as if it were copied data from an LDS pdf directory."]
["Once the data in there, press \"Concise\" to clean up your data."]
["Once the data is cleaned up, click \"Import to List to get it in list form.\""]
[]
[]
[]
[]
[]
[]
[]
["PUT LIST RIGHT HERE"]

{"sheet":"Organized Data","index":3,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
[null,null,null,null,null,null,null,null,null,"County"]
[]
["Last Name","First Name","Street","City/Zip","Lat ","Long"]

{"sheet":"Organized Data 2","index":4,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,13,1,14],[2,13,2,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Your Current Address"]
[]
["Last Name","First Name","Street","City/Zip","Lat ","Long","Distance"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lat","Long"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Route 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Route 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Route 3"]

{"sheet":"Help","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DummyData","index":6,"n_rows":253,"n_cols":32,"rows_kept":253,"cut":false,"hidden":false,"merged":[]}
["A",null,null,"BEAVER","BOX ELDER","CACHE","CARBON","DAGGETT","DAVIS","DUCHESNE","EMERY","GARFIELD","GRAND","IRON","JUAB","KANE","MILLARD","MORGAN","PIUTE","RICH","SALT LAKE","SAN JUAN","SANPETE","SEVIER","SUMMIT","TOOELE","UINTAH","UTAH","WASATCH","WASHINGTON","WAYNE","WEBER"]
["Smith",null,null,"BEAVER CITY","BEAR RIVER","AMALGA","CARBON COUNTY","DAGGETT COUNTY","BOUNTIFUL","ALTAMONT","CASTLE DALE","ANTIMONY","CASTLE VALLEY","BRIAN HEAD","EUREKA","ALTON","DELTA","MORGAN CITY","CIRCLEVILLE","GARDEN CITY","ALTA","BLANDING","CENTERFIELD","ANNABELLA","COALVILLE","ERDA","BALLARD","ALPINE","CHARLESTON","APPLE VALLEY","BICKNELL","FALCON HILL RIVERDALE"]
["Joseph",null,null,"BEAVER COUNTY","BOX ELDER COUNTY","CACHE COUNTY","EAST CARBON","DUTCH JOHN","CENTERVILLE","DUCHESNE CITY","CLAWSON","BOULDER","GRAND COUNTY","CEDAR CITY","JUAB COUNTY","BIG WATER","FILLMORE","MORGAN COUNTY","JUNCTION","LAKETOWN","BLUFFDALE","MONTICELLO","EPHRAIM","AURORA","FRANCIS","GRANTSVILLE","NAPLES","AMERICAN FORK","DANIEL","ENTERPRISE","HANKSVILLE","FALCON HILL ROY"]
["1595 S. 400 E.",null,null,"MILFORD","BRIGHAM CITY","CACHE VALLEY TRANSIT","HELPER","MANILA","CLEARFIELD","DUCHESNE COUNTY","CLEVELAND","BRYCE CANYON","MOAB","ENOCH","LEVAN","GLENDALE","HINCKLEY",null,"KINGSTON","RANDOLPH","COPPERTON TOWNSHIP","SAN JUAN COUNTY","FAIRVIEW","CENTRAL VALLEY","HENEFER","LAKEPOINT","UINTAH COUNTY","BLUFFDALE SOUTH","HEBER","HILDALE","LOA","FARR WEST"]
["Orem, Utah 84058",null,null,"MINERSVILLE","CORINNE","CLARKSTON","PRICE",null,"CLINTON","MYTON","ELMO","CANNONVILLE",null,"IRON COUNTY","MONA","KANAB","HOLDEN",null,"MARYSVALE","RICH COUNTY","COTTONWOOD HEIGHTS",null,"FAYETTE","ELSINORE","KAMAS","LINCOLN","VERNAL","CEDAR FORT","HIDEOUT","HURRICANE","LYMAN","HARRISVILLE"]
["Smith",null,null,null,"DEWEYVILLE","CORNISH","SCOFIELD",null,"DAVIS COUNTY","ROOSEVELT","EMERY CITY","ESCALANTE",null,"KANARRAVILLE","NEPHI","KANE COUNTY","KANOSH",null,"PIUTE COUNTY","WOODRUFF","DRAPER",null,"FOUNTAIN GREEN","GLENWOOD","OAKLEY","RUSH VALLEY",null,"CEDAR HILLS","INDEPENDENCE","IVINS","TORREY","HOOPER"]
["Joseph",null,null,null,"ELWOOD","HYDE PARK","WELLINGTON",null,"FALCON HILL CLEARFIELD","TABIONA","EMERY COUNTY","GARFIELD COUNTY",null,"PARAGONAH","ROCKY RIDGE","ORDERVILLE","LEAMINGTON",null,null,null,"EMIGRATION CANYON TOWNSHIP",null,"GUNNISON","JOSEPH","PARK CITY","STANSBURY PARK",null,"DRAPER SOUTH","INTERLAKEN","LA VERKIN","WAYNE COUNTY","HUNTSVILLE"]
["1595 S. 400 E.",null,null,null,"FIELDING","HYRUM",null,null,"FALCON HILL DAVIS",null,"FERRON","HATCH",null,"PAROWAN","SANTAQUIN SOUTH",null,"LYNNDYL",null,null,null,"HERRIMAN",null,"MANTI","KOOSHAREM","SNYDERVILLE BASIN TR","STOCKTON",null,"EAGLE MOUNTAIN","MIDWAY","LEEDS",null,"MARRIOT-SLATERVILLE"]
["Orem, Utah 84058",null,null,null,"GARLAND","LEWISTON",null,null,"FALCON HILL SUNSET",null,"GREEN RIVER","HENRIEVILLE",null,null,null,null,"MEADOW",null,null,null,"HOLLADAY",null,"MAYFIELD","MONROE","SUMMIT COUNTY","TOOELE CITY",null,"ELK RIDGE","PARK CITY EAST","NEW HARMONY TOWN",null,"NORTH OGDEN"]
["Smith",null,null,null,"HONEYVILLE","LOGAN",null,null,"FARMINGTON",null,"HUNTINGTON","PANGUITCH",null,null,null,null,"MILLARD COUNTY",null,null,null,"KEARNS TOWNSHIP",null,"MORONI","REDMOND",null,"TOOELE COUNTY",null,"FAIRFIELD","WALLSBURG","ROCKVILLE",null,"OGDEN"]
["Joseph",null,null,null,"HOWELL","MENDON",null,null,"FRUIT HEIGHTS",null,"ORANGEVILLE","TROPIC",null,null,null,null,"OAK CITY",null,null,null,"MAGNA TOWNSHIP",null,"MT. PLEASANT","RICHFIELD",null,"VERNON",null,"GENOLA","WASATCH COUNTY","SANTA CLARA",null,"PLAIN CITY"]
["Cherry Hill Apts # 1754",null,null,null,"MANTUA","MILLVILLE",null,null,"KAYSVILLE",null,null,null,null,null,null,null,"SCIPIO",null,null,null,"MIDVALE",null,"SANPETE COUNTY","SALINA",null,"WENDOVER",null,"GOSHEN",null,"SPRINGDALE",null,"PLEASANT VIEW"]
["Orem, Utah 84058",null,null,null,"PERRY","NEWTON",null,null,"LAYTON",null,null,null,null,null,null,null,null,null,null,null,"MILLCREEK",null,"SPRING CITY","SEVIER COUNTY",null,null,null,"HIGHLAND",null,"ST. GEORGE",null,"RIVERDALE"]
["Smith",null,null,null,"PLYMOUTH","NIBLEY",null,null,"NORTH SALT LAKE",null,null,null,null,null,null,null,null,null,null,null,"MURRAY",null,"STERLING","SIGURD",null,null,null,"LEHI",null,"TOQUERVILLE",null,"ROY"]
["Joseph",null,null,null,"PORTAGE","NORTH LOGAN",null,null,"SOUTH WEBER",null,null,null,null,null,null,null,null,null,null,null,"RIVERTON",null,"WALES",null,null,null,null,"LINDON",null,"VIRGIN",null,"SOUTH OGDEN"]
["341 E Chapel Cir",null,null,null,"SNOWVILLE","PARADISE",null,null,"SUNSET",null,null,null,null,null,null,null,null,null,null,null,"SALT LAKE CITY",null,null,null,null,null,null,"MAPLETON",null,"WASHINGTON CITY",null,"UINTAH"]
["Orem, Utah 84058",null,null,null,"TREMONTON","PROVIDENCE",null,null,"SYRACUSE",null,null,null,null,null,null,null,null,null,null,null,"SALT LAKE COUNTY",null,null,null,null,null,null,"OREM",null,"WASHINGTON COUNTY",null,"WASHINGTON TERRACE"]
["Smith",null,null,null,"WILLARD","RICHMOND",null,null,"WEST BOUNTIFUL",null,null,null,null,null,null,null,null,null,null,null,"SANDY",null,null,null,null,null,null,"PAYSON",null,null,null,"WEBER COUNTY"]
["Joseph",null,null,null,null,"RIVER HEIGHTS",null,null,"WEST POINT",null,null,null,null,null,null,null,null,null,null,null,"SOUTH JORDAN",null,null,null,null,null,null,"PLEASANT GROVE",null,null,null,"WEST HAVEN"]
["1775 S 290 E",null,null,null,null,"SMITHFIELD",null,null,"WOODS CROSS",null,null,null,null,null,null,null,null,null,null,null,"SOUTH SALT LAKE",null,null,null,null,null,null,"PROVO"]
["Orem, Utah 84058-7927",null,null,null,null,"TRENTON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAYLORSVILLE",null,null,null,null,null,null,"SALEM"]
["Smith",null,null,null,null,"WELLSVILLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT DATA CTR SL CO",null,null,null,null,null,null,"SANTAQUIN"]
["Joseph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST JORDAN",null,null,null,null,null,null,"SARATOGA SPRINGS"]
["428 E 1600 S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST VALLEY CITY",null,null,null,null,null,null,"SPANISH FORK"]
["Orem, Utah 84058",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WHITE CITY TOWNSHIP",null,null,null,null,null,null,"SPRINGVILLE"]
["Smith",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT DATA CTR UT CO"]
["Joseph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UTAH COUNTY"]
["1718 So. Village Bldg G",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VINEYARD"]
["Orem, Utah 84058",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOODLAND HILLS"]
["B"]
["Smith"]
["Joseph"]
["330 E 1730 S"]
["Orem, Utah 84058-7913"]
["Smith"]
["Joseph"]
["1562 S 450 E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1730 S 310 E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1760 Village Ln"]
["Unit 308"]
["Orem, Utah 84058-7948"]
["Smith"]
["Joseph"]
["Smith"]
["Joseph"]
["454 E 1600 S"]
["Orem, Utah"]
["Smith"]
["Joseph"]
["326 E 1600 S"]
["Apt 1"]
["Orem, Utah 84058-7900"]
["Cherry Hill 2nd Ward"]
["For Church Use Only - Do not copy without permission from your local church leaders"]
["Not to be Used for Any Commercial, Business, or Political Purpose"]
["2011 Intellectual Reserve, Inc. All rights reserved"]
["2017-12-12"]
["Smith"]
["Joseph"]
["476 East 1600 South"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1634 S 350 E"]
["Orem, Utah 84058-7905"]
["Smith"]
["Joseph"]
["430 E 1500 S"]
["Orem, Utah 84058-7618"]
["Smith"]
["Joseph"]
["1632 S 350 E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1751 Village Ln"]
["Orem, Utah 84058-7982"]
["C"]
["Smith"]
["Joseph"]
["443 E 1600 S Apt 2"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1748 Village Ln"]
["Orem, Utah 84058-7982"]
["Smith"]
["Joseph"]
["1735 S 340 E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1705 S Village Ln Bldg E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1709 S. Village Lane"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1565 S 400 E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1759 S 340 E"]
["Orem, Utah 84058-7929"]
["Smith"]
["Joseph"]
["1759 South 340 East"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["333 E 1730 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1768 South 400 East"]
["Orem, Utah 84058"]
["Cherry Hill 2nd Ward"]
["For Church Use Only - Do not copy without permission from your local church leaders"]
["Not to be Used for Any Commercial, Business, or Political Purpose"]
["2011 Intellectual Reserve, Inc. All rights reserved"]
["2017-12-12"]
["Smith"]
["Joseph"]
["329 E 1730 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["365 E 1655 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["365 E 1655 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1706 South Village Lane"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["339 E 1655 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1711 Village Ln"]
["Orem, Utah 84058-7949"]
["Smith"]
["Joseph"]
["1585 S 400 E"]
["Orem, Utah 84058-8304"]
["Smith"]
["Joseph"]
["Smith"]
["Joseph"]
["384 E 1655 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["384 E 1655 S"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1760 Village Ln"]
["Unt 412"]
["Orem, Utah 84058-7951"]
["Smith"]
["Joseph"]
["394 E 1600 S"]
["Orem, Utah 84058-7907"]
["D"]
["Smith"]
["Joseph"]
["333 E. 1730 S."]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1760 Village Ln"]
["Unt 206"]
["Orem, Utah 84058-7946"]
["Cherry Hill 2nd Ward"]
["For Church Use Only - Do not copy without permission from your local church leaders"]
["Not to be Used for Any Commercial, Business, or Political Purpose"]
["2011 Intellectual Reserve, Inc. All rights reserved"]
["2017-12-12"]
["Smith"]
["Joseph"]
["1562 S 450 E"]
["Orem, Utah 84058-8303"]
["Smith"]
["Joseph"]
["1726 Village Ln"]
["Orem, Utah 84058-7983"]
["Smith"]
["Joseph"]
["1646 S 400 E"]
["Orem, Utah 84058-"]
["Smith"]
["Joseph"]
["1646 S 400 E"]
["Orem, Utah"]
["Smith"]
["Joseph"]
["1573 S 400 E"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1760 Village Ln"]
["Unit 205"]
["Orem, Utah 84058-7946"]
["E"]
["Smith"]
["Joseph"]
["1701 South Village Lane"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["310 East 1730 South"]
["Orem, Utah 84058"]
["Smith"]
["Joseph"]
["1518 S 450 E"]
["Orem, Utah 84058-7633"]
["Smith"]
["Joseph"]
["1760 Village Ln"]
["Unit 210"]
["Orem, Utah 84058-7946"]
["Smith"]
["Joseph"]
["1760 Village Ln"]
["Unt 112"]
["Orem, Utah 84058-7945"]
["Smith"]
["Joseph"]
["412 E 1600 S"]
["Orem, Utah 84097"]
["F"]
["Smith"]
["Joseph"]
["431 E 1600 S"]
["Orem, Utah 84058"]
["Cherry Hill 2nd Ward"]
["For Church Use Only - Do not copy without permission from your local church leaders"]
["Not to be Used for Any Commercial, Business, or Political Purpose"]
["2011 Intellectual Reserve, Inc. All rights reserved"]
["2017-12-12"]